
/****** Object:  Table [dbo].[Build4Log]    Script Date: 12/06/2011 23:04:31 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Build4Log](
	[BuildId] [bigint] NOT NULL,
	[EntDate] [datetime] NOT NULL,
	[IONumber] [nvarchar](50) NOT NULL,
	[TradeMoney] [money] NOT NULL,
	[DiscountOnItem] [money] NOT NULL,
	[VATMoney] [money] NOT NULL,
	[TotalMoney] [money] NOT NULL,
	[UserId] [bigint] NOT NULL,
	[CounterId] [bigint] NOT NULL,
	[Note] [nvarchar](50) NOT NULL,
	[StatusBill] [bit] NOT NULL,
	[ClientCode] [nvarchar](255) NOT NULL,
	[SyncCode] [nvarchar](255) NOT NULL,
	[TimeStamp] [timestamp] NOT NULL,
	[DiscountOnBuildByTotalMoney] [money] NOT NULL,
	[DiscountOnBuildByTotalMoneyId] [bigint] NULL,
	[DiscountOnBuildByTotalMoneyDescription] [nvarchar](500) NOT NULL,
	[CustomerPaymentId] [bigint] NULL,
	[TimeStampCode] [varbinary](8) NULL,
	[DiscountOnBuild] [money] NOT NULL,
	[DiscountPercentOnBuild] [int] NOT NULL,
	[LogType] [nvarchar](255) NULL,
	[LogDate] [datetime] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


